package com.neusoft.elm.dao.impl;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.neusoft.elm.dao.AdminDao;
import com.neusoft.elm.po.Admin;
import com.neusoft.elm.util.DBUtil;

public class AdminDaoImpl implements AdminDao {


	private Connection con = null;
	private PreparedStatement pst = null;
	private ResultSet rs = null;
	
	
	@Override
	public Admin getAdminByNameByPass(String adminName, String password) {
		// TODO Auto-generated method stub
		Admin admin = null;
		
		String sql="SELECT * FROM admin WHERE adminName = ?  AND password = ?";
		
		
		
		try {
			
			//1.连接数据库
			con =  DBUtil.getConnection();
			pst = con.prepareStatement(sql);
			pst.setString(1, adminName);
			pst.setString(2, password);
			rs =  pst.executeQuery();
			
			
			//2.遍历执行结果
			while(rs.next()){
				admin = new Admin();
				admin.setAdminId(rs.getInt("adminId"));
				admin.setAdminName(rs.getString("adminName"));
				admin.setPassword(rs.getString("password"));
			}
			
			
		} catch (Exception e) {
			
			e.printStackTrace();
		}finally{
			
			
			DBUtil.close(rs, pst, con);
			
			
		}
		
		
		
		
		
		
		
		return admin;
	}









}